PORTFOLIO
POWER BI
Adam Chnok
Business Intelligence Analyst
adamchnok@gmail.com
& ANALYTICS
Showcasing Dashboard Design, Data Modeling, and
Generative AI in Analytics
Content Overview
Showcasing Dashboard Design, Data Modeling, and
Generative AI in Analytics
Server Backup Monitoring Dashboard
01
06
02
07
Proficiency in Generative AI
Security Operations Dashboard
Use Cases in Analytics & Reporting
Incident, Request, Change Dashboard (1)
Incident, Request, Change Dashboard (2)
AI
-
Assisted Documentation
Other Dashboards
03
04
08
05
Portfolio / Project Samples (Power BI)
Server Backup Monitoring Dashboard
Server Backup Monitoring Dashboard:
Business Context
Situation
•
The stakeholders needed a real
-
time dashboard to track which
servers restarted successfully,
which ones failed and monitor
backup status to ensure
availability.
•
Their existing reporting tool was
limited, required heavy manual
effort, and slowed down incident
detection for the monitoring team.
My Role
Data Sources / ETL
•
Designed and developed the
dashboard based on client
requirements.
•
Collaborated with stakeholders to
define KPIs for server health and
backup availability.
•
SQL database of HP server
hosts.
•
Connected via
DirectQuery
for live, dynamic reporting.
clearer visuals and critical metrics for incident detection.
90%
Reduction in Manual Reporting
Eliminated manual reporting on the whole project
5x
Improved Response
Faster incident detection and resolution compared to
previous tools
Delivered
Impact / Outcome
Security Operations Dashboard
Security Operations Dashboard:
Business Context
Situation
•
The security team was responsible for
sending monthly reports to
executives, but the process was
entirely manual. Preparing the slides
often took several days of effort.
•
The reports were static and lacked
flexibility, executives couldn’t easily
filter by specific months or look back
at historical data without requesting
additional files.
My Role
Data Sources / ETL
•
Designed and developed a new
dashboard tailored to the team’s
reporting needs, focusing on
automation and interactivity.
•
Optimized an existing dashboard by
improving its structure and
correcting KPI calculations using
DAX measures to ensure data
accuracy.
•
Data was provided through
monthly Excel extracts sent by the
security team.
•
The files were cleaned and
transformed in Power Query
before being modeled in Power BI.
50% Automation
Reduced the team’s end
-
of
-
month reporting workload,
allowing them to focus on higher
-
value security tasks instead of
manual reporting.
Introduced
dynamic features such as slicers for date and month selection,
enabling executives to easily drill into past performance without needing
separate reports.
Improved
overall accessibility, eliminating the inefficiencies of tracking
outdated versions of the report.
Impact / Outcome
Incident, Request, Change, SLA & Backlog Dashboard
Problem 1
•
SLA measurements in ServiceNow
were often incorrect because the
developers responsible for
maintaining them did not implement
the necessary adjustments.
•
To avoid delays and repeated back
-
and
-
forth requests, we needed to
create our own accurate version of
SLA reporting.
Problems 2 & 3
Problem 4
•
Stakeholder teams were not highly
communicative or organized, which
meant that even small updates could
take weeks to be implemented.
•
ServiceNow’s built
-
in reporting was
too basic and limited, and some
required measurements could not be
created directly in the tool.
•
Stakeholders wanted a more
reliable and visually clear
reporting solution that allowed
them to track SLAs and tickets
anytime without depending on
manual updates.
Incident, Request, Change, SLA & Backlog
Dashboard
:
Business Context (Problems)
Incident, Request, Change, SLA & Backlog
Dashboard
:
Business Context (Solutions)
My Role
•
Designed and developed an intuitive Power BI
dashboard to present SLA metrics and KPIs
requested by stakeholders.
•
Created custom DAX measures to replicate and
correct SLA calculations, ensuring data was both
accurate and live.
•
Adapted the design and color scheme to
stakeholder preferences, focusing on simplicity
and readability rather than flashy visuals.
Data Sources/ ETL
•
Configured scheduled ServiceNow data
extractions that were automatically delivered to
Outlook.
•
Set up Power Automate to sync Outlook with
SharePoint, ensuring each new extraction
replaced the previous file seamlessly and on daily
basis.
•
Connected Power BI to SharePoint so the report
stayed updated automatically without requiring
manual refreshes or SQL/API setup.
Impact / Outcome
Delivered
a fully automated reporting process, removing the need for
manual intervention or complex SQL/API integrations.
Over
10
executives
used the dashboard daily, making it a trusted tool for SLA
and ticket tracking.
Helped
executives keep weekly meetings on schedule by providing accurate,
timely insights, unlike the old static reports that often caused delays.
Incident, Request, Change & SLA Tables Dashboard
Situations 1 & 2
•
The IT team needed an automated reporting
solution to present accurate metrics to multiple
stakeholders.
•
All stakeholders used the same ticketing tool,
which often caused data overlaps, mixed reports,
and in some cases, incorrect information.
Situations 3 & 4
•
During monthly reviews, the IT team had to
manually prepare over 8 different PowerPoint
decks, each tailored to a specific stakeholder’s
metrics. This was time
-
consuming and error
-
prone.
•
Stakeholders insisted on reports being presented
in table format similar to Excel, even though
Power BI is not natively optimized for Excel
-
style
layouts.
Incident, Request, Change & SLA Tables
Dashboard:
Business Context (Problems)
My Role
•
Designed and developed an intuitive Power BI
dashboard that replicated SLA and KPI reports in
a clean, Excel
-
like format.
•
Built a Project slicer to differentiate each
stakeholder’s company data, ensuring that all
visuals, logos, and metrics dynamically adjusted
based on the selected project.
•
Enabled stakeholders to use the same report but
view it in a personalized way depending on the
project selection.
Data Sources/ ETL
•
Used raw Excel extractions provided by IT teams.
•
Cleaned and transformed data in Power Query
before building the model in Power BI.
Incident, Request, Change & SLA Tables
Dashboard:
Business Context (Solutions)
Impact / Outcome
Delivered
a simple, user
-
friendly dashboard that looked and functioned almost
exactly like stakeholders’ familiar Excel tables by mimicking the pivot
tables, easing adoption.
Saved
the IT team hours of manual effort each
month by eliminating the need to filter massive Excel extracts and
build 8 separate stakeholder
-
specific versions.
Standardized
reporting timelines and all stakeholders now receive their reports on
the same day each month, ensuring consistency and better meeting
preparation.
Other Dashboards
Generative AI Familiarity
Proficiency in Using
Generative AI
•
Proficient use of generative AI tools
like ChatGPT and Copilot for
analytics and reporting tasks.
•
Daily use for creating,
troubleshooting, and optimizing DAX
measures, SQL queries, and Power BI
visuals.
•
Effective in prompting AI for both
technical solutions (formulas,
queries) and business
-
level
explanations or summaries.
•
Use AI as a productivity booster to
reduce manual effort and accelerate
dashboard development.
•
Used ChatGPT to troubleshoot
complex DAX formulas and
optimize SQL queries.
DAX/SQL Help
Use Cases in Analytics & Reporting
Use Cases in Analytics & Reporting
•
AI
-
assisted generation of measures,
KPIs, and visual explanations.
Power BI Reports
•
AI optimized report creation, reduced errors, sped up
delivery, and added final touches like formatting,
highlighting metrics, and visual indicators (e.g.,
smiley face for SLA)
Result
Use Cases in Analytics & Reporting
Data QA
1
Data Validation
: Checking source data for completeness,
accuracy, and consistency before importing into Power BI.
2
Logic & Calculation Review
: Verifying DAX measures, SQL
queries, and transformations to ensure calculations are
correct.
3
Visual Inspection:
Ensuring charts, tables, and KPIs
display accurate values and match source data. Checking
that formatting, colors, and labels are consistent and
readable.
4
End
-
to
-
End Testing:
Simulating real scenarios with
filters, slicers, and dynamic selections to confirm
interactivity works as intended. Comparing dashboard
results against historical reports or benchmark
Use Cases in Analytics &
Reporting
Generative AI as a Co
-
Pilot
Generative AI helps me build dashboards faster,
optimize reports with final touches,
and deliver clearer, more accurate insights with less
manual effort.
AI
-
Assisted Documentation
Advanced Visualization Features
AI
-
Assisted Documentation
•
Dashboard Summaries:
AI generates clear, business
-
friendly
explanations of KPIs and metrics for stakeholders.
•
Process Guides:
Drafts step
-
by
-
step instructions for
maintaining or refreshing dashboards.
•
Internal SOPs:
Quickly creates standardized procedures for
repetitive tasks.
•
Training Support:
Produces onboarding materials or FAQs for
team members.
AI
-
assisted documentation can help create and improve emails,
notes, checklists, step
-
by
-
step guides, and flowcharts, turning
technical work into clear, actionable information for
stakeholders and team members.
Thank you for your time
Adam Chnok
Business Intelligence Analyst
adamchnok@gmail.com